<?php

class ScrapperController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
            'postOnly + delete', // we only allow deletion via POST request
        );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {
        return array(
            array('allow', // allow all users to perform 'index' and 'view' actions
                'actions' => array('index', 'view', 'addAccount', 'download', 'updateScrapper'),
                'users' => array('*'),
            ),
            array('allow', // allow authenticated user to perform 'create' and 'update' actions
                'actions' => array('create', 'update'),
                'users' => array('@'),
            ),
            array('allow', // allow admin user to perform 'admin' and 'delete' actions
                'actions' => array('admin', 'delete'),
                'users' => array('admin'),
            ),
            array('deny', // deny all users
                'users' => array('*'),
            ),
        );
    }

    public function TestactionDownload() {
        $response = "<Response>";
        $criteria = new CDbCriteria;
        $criteria->condition = "user_id like '%'";
        $list = Scrapper::model()->findAll($criteria);

        $childRes = "<accounts>";
        foreach ($list as $account) {
            $childRes = $childRes . "<account>";
            $childRes = $childRes . "<id>" . $account->id . "</id>";
            $childRes = $childRes . "<user_id>" . $account->user_id . "</user_id>";
            $childRes = $childRes . "<username>" . $account->username . "</username>";
            $childRes = $childRes . "<phone>" . $account->phone . "</phone>";
            $childRes = $childRes . "<date_on>" . $account->date_on . "</date_on>";
            $childRes = $childRes . "<status>" . $account->status . "</status>";
            $childRes = $childRes . "</account>";
        }
        $childRes = $childRes . "</accounts>";

        $response = $response . "<errorcode>001</errorcode><message>Record found</message>";
        $response = $response . $childRes . "</Response>";
        echo $response;
        //print_r($xml);
    }

    public function actionDownload() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;
        $action = $xml->action;
        $startDateRange = $xml->startDateRange;
        $endDateRange = $xml->endDateRange;
        $startIdRange = $xml->startIdRange;
        $endIdRange = $xml->endIdRange;
        $errorMsg = $this->authenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $criteria = new CDbCriteria;
        if ($action == '*') {
            $criteria->condition = "user_id like '%' AND status = 0";
        }

        if ($action == 'ID') {
            $criteria->condition = "id >= $startIdRange AND id <= $endIdRange AND status = 0";
        }

        if ($action == 'D') {
            $criteria->condition = "date_on >= '$startDateRange' AND date_on <= '$endDateRange' AND status = 0";
        }

        $list = Scrapper::model()->findAll($criteria);

        $childRes = "<accounts>";
        foreach ($list as $account) {
            $childRes = $childRes . "<account>";
            $childRes = $childRes . "<id>" . $account->id . "</id>";
            $childRes = $childRes . "<user_id>" . $account->user_id . "</user_id>";
            $childRes = $childRes . "<username>" . $account->username . "</username>";
            $childRes = $childRes . "<phone>" . $account->phone . "</phone>";
            $childRes = $childRes . "<date_on>" . $account->date_on . "</date_on>";
            $childRes = $childRes . "<status>" . $account->status . "</status>";
            $childRes = $childRes . "</account>";
        }
        $childRes = $childRes . "</accounts>";

        $response = $response . "<errorcode>001</errorcode><message>Record found</message>";
        $response = $response . $childRes . "</Response>";
        echo $response;
        //print_r($xml);
    }

    public function XXXactionUpdateScrapper() {
        $response = "<Response>";
        Scrapper::model()->updateAll(array('status' => 1));

        $response = $response . "<errorcode>001</errorcode><message>Updated all successfully.</message></Response>";

        echo $response;
    }

    public function actionUpdateScrapper() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;
        $action = $xml->action;
        $startDateRange = $xml->startDateRange;
        $endDateRange = $xml->endDateRange;
        $startIdRange = $xml->startIdRange;
        $endIdRange = $xml->endIdRange;
        $working = $xml->working;
        $errorMsg = $this->authenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        if ($action == '*') {
            Scrapper::model()->updateAll(array('status' => $working));
        } else if ($action == 'ID') {
            Scrapper::model()->updateAll(array('status' => $working), "id >= $startIdRange AND id <= $endIdRange");
        } else if ($action == 'D') {
            Scrapper::model()->updateAll(array('status' => $working), "date_on >= '$startDateRange' AND date_on <= '$endDateRange'");
        }
        $response = $response . "<errorcode>001</errorcode><message>Updated all successfully.</message></Response>";

        echo $response;
    }

    /**
     * 0 means admin, 1 means super member and 2 means member
     */
    public function actionAddAccount() {
        $response = "<Response>";
        if (!isset($_POST['request'])) {
            $response = $response . "<errorcode>000</errorcode><message>Request paramater is not found.</message></Response>";
            echo $response;
            return;
        }
        $request = $_POST['request'];

        $xml = simplexml_load_string($request);
        $username = $xml->username;
        $password = $xml->password;

        $errorMsg = $this->authenticate($username, $password);
        if ($errorMsg != "") {
            $response = $response . "<errorcode>000</errorcode><message>hereeee" . $errorMsg . "</message></Response>";
            echo $response;
            return;
        }

        $record = UserAccount::model()->findByAttributes(array('username' => $username));
        $success = 0;
        $failed = 0;
        foreach ($xml->numbers as $record) {
            $model = new Scrapper;
            $model->user_id = $record->id;
            $model->username = $xml->email;
            $model->password = $xml->emailpassword;
            $model->phone = $record->number;
            $model->status = 0;
            $model->date_on = date("Y-m-d H:i:s");
            if ($model->save()) {
                $success = $success + 1;
            } else {
                $failed = $failed + 1;
            }           
        }
        $response = $response . "<errorcode>001</errorcode><success>$success</success><failed>$failed</failed><message>Account has been created successfully.</message></Response>";
      
        echo $response;
        //print_r($xml);
    }

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new Scrapper;

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Scrapper'])) {
            $model->attributes = $_POST['Scrapper'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Scrapper'])) {
            $model->attributes = $_POST['Scrapper'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        $this->loadModel($id)->delete();

        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (!isset($_GET['ajax']))
            $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
    }

    /**
     * Lists all models.
     */
    public function actionIndex() {
        $dataProvider = new CActiveDataProvider('Scrapper');
        $this->render('index', array(
            'dataProvider' => $dataProvider,
        ));
    }

    /**
     * Manages all models.
     */
    public function actionAdmin() {
        $model = new Scrapper('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['Scrapper']))
            $model->attributes = $_GET['Scrapper'];

        $this->render('admin', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer $id the ID of the model to be loaded
     * @return Scrapper the loaded model
     * @throws CHttpException
     */
    public function loadModel($id) {
        $model = Scrapper::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param Scrapper $model the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'scrapper-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

}
